RewardEligibilityPropertyType

Entity Definition

Logical Name : RewardEligibilityPropertyType
Physical Name : CO_RWD_EL_PRY_TYP

A list of valid RewardEligibilityTypes represented in the ARTS ODM. This list may be extended by retailers along with RewardEligibilityRule subtype entities. BRAND_NAME Brand ARTS ODM V7.2 CALENDAR_ID Calendar Period part 1 ARTS ODM V7.2 CALENDAR_LEVEL_ID Calendar Period part 2 ARTS ODM V7.2 CALENDAR_PERIOD_ID Calendar Period part 3 ARTS ODM V7.2 CHANNEL_ID Channel ARTS ODM V7.2 CUSTOMER_ACCOUNT_ID Customer Account ARTS ODM V7.2 CUSTOMER_MEMBER_PROGRAM_ACCOUNT_ID Customer Membershipp Prog Acct ARTS ODM V7.2 EMPLOYEE_DISCOUNT_GROUP_ID Employee Discount Group ARTS ODM V7.2 ITEM_ID Single Item ID (SKU) ARTS ODM V7.2 MANUFACTURER_ID Manufacturer ARTS ODM V7.2 MARKET_BASKET_TRIGGER_ID (follow up on this one) ARTS ODM V7.2 MERCHANDISE_HIERARCHY_GROUP Merch Hier. Group (we're simplifying this will require tree view to create UI) ARTS ODM V7.2 PRICE_LINE_ID Price Line ARTS ODM V7.2 PRICE_OVERRIDE Flagged overriden price - no ARTS equivalent SALE_RTN_CLASS This should be handled in MERCHANDISE HIERARCHY GROUP SALE_RTN_DEPARTMENT This should be handled in MERCHANDISE HIERARCHY GROUP SALE_RTN_ITEM_CLEARANCE no ARTS equivalent SALE_RTN_ITEM_DISCOUNTED Sale Return item is already discounted SALE_RTN_ITEM_STOCK_STATUS no ARTS equivalent SALE_RTN_ITEM_VENDOR This should be handled by mfg / brand SALE_RTN_QUANTITY Eligibilty trigger qty SALE_RTN_SKU Handled by ITEM_ID SALE_RTN_STYLE This should be handled in MERCHANDISE HIERARCHY GROUP SALE_RTN_SUBCLASS This should be handled in MERCHANDISE HIERARCHY GROUP SALE_RTN_SUBDEPARTMENT This should be handled in MERCHANDISE HIERARCHY GROUP SALE_RTN_UNIT_PRICE Eligibilty trigger retail price SEASON see Calendar SEQ_NUMBER Comparison is between the line item number from sale return row and the value in VALUE1 TENDER_MEDIA_BRAND_ID Branded Tender Type part 2 ARTS ODM V7.2 TENDER_TYPE_CODE Branded Tender Type part 1 ARTS ODM V7.2

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
RewardEligibilityPropertyTypeCode (PK) A short code used to identify a valid RewardEligibilityPropertyType. Valid values are: BRAND_NAME Brand ARTS ODM V7.2 CALENDAR_ID Calendar Period part 1 ARTS ODM V7.2 CALENDAR_LEVEL_ID Calendar Period part 2 ARTS ODM V7.2 CALENDAR_PERIOD_ID Calendar Period part 3 ARTS ODM V7.2 CHANNEL_ID Channel ARTS ODM V7.2 CUSTOMER_ACCOUNT_ID Customer Account ARTS ODM V7.2 CUSTOMER_MEMBER_PROGRAM_ACCOUNT_ID Customer Membershipp Prog Acct ARTS ODM V7.2 EMPLOYEE_DISCOUNT_GROUP_ID Employee Discount Group ARTS ODM V7.2 ITEM_ID Single Item ID (SKU) ARTS ODM V7.2 MANUFACTURER_ID Manufacturer ARTS ODM V7.2 MARKET_BASKET_TRIGGER_ID (follow up on this one) ARTS ODM V7.2 MERCHANDISE_HIERARCHY_GROUP Merch Hier. Group (we're simplifying this will require tree view to create UI) ARTS ODM V7.2 PRICE_LINE_ID Price Line ARTS ODM V7.2 PRICE_OVERRIDE Flagged overriden price - no ARTS equivalent SALE_RTN_CLASS This should be handled in MERCHANDISE HIERARCHY GROUP SALE_RTN_DEPARTMENT This should be handled in MERCHANDISE HIERARCHY GROUP SALE_RTN_ITEM_CLEARANCE no ARTS equivalent SALE_RTN_ITEM_DISCOUNTED Sale Return item is already discounted SALE_RTN_ITEM_STOCK_STATUS no ARTS equivalent SALE_RTN_ITEM_VENDOR This should be handled by mfg / brand SALE_RTN_QUANTITY Eligibilty trigger qty SALE_RTN_SKU Handled by ITEM_ID SALE_RTN_STYLE This should be handled in MERCHANDISE HIERARCHY GROUP SALE_RTN_SUBCLASS This should be handled in MERCHANDISE HIERARCHY GROUP SALE_RTN_SUBDEPARTMENT This should be handled in MERCHANDISE HIERARCHY GROUP SALE_RTN_UNIT_PRICE Eligibilty trigger retail price SEASON see Calendar SEQ_NUMBER Comparison is between the line item number from sale return row and the value in VALUE1 TENDER_MEDIA_BRAND_ID Branded Tender Type part 2 ARTS ODM V7.2 TENDER_TYPE_CODE Branded Tender Type part 1 ARTS ODM V7.2 CD_RWD_EL_PRY_TY Code varchar(20)
Description Short description of a reward eligibility property type. Used for reporting and screens to provide meaningful display of a property type. DE_RWD_EL_PRY_TY DescriptionShort varchar(255)

Relationships

Parent Entity Verb Phrase Child Entity
RewardEligibilityPropertyType classifies RewardEligibilityRule

Logical Views containing RewardEligibilityPropertyType

Logical View
Logical 01400 - Item Rewards Derivation - Transaction Level